Limitations

When defining a task with MapR Streams as the target endpoint, the following limitations apply:

• Unlimited LOB size is not supported. Therefore, when replicating from source tables with LOB columns, do not select the Allow unlimited LOB size option.

  For more information on defining LOB settings, see Target metadata.

• Batch optimized apply mode is not supported. If this mode is set, the task will automatically switch to Transactional apply mode and issue an appropriate warning.

  For more information on these modes, see Change Processing Tuning.

• Store Changes mode is not supported.

  For more information on Store Changes mode, see Adding tasks.

• MapR Streams topic names cannot exceed 255 characters and can only contain the following characters:

  a-z|A-Z|0-9|. (dot)|_(underscore)|-(minus)

  If the source table names exceed the maximum permitted length or contain unsupported characters, you need to either modify the names before starting the task or define a global transformation. For information on defining global transformations, see Starting the Global Transformation Rules wizard.

• The Ignore ALTER Apply Changes setting is not supported for changes to source data types and table renaming.

• Column names must begin with [A-Za-z_] (letters or an underscore) followed by [A-Za-z0-9_] (letters, digits, or an underscore). For example, _Test_ is a valid column name whereas &Test is not.

  If a source column name does not adhere to this rule, then a transformation should be used to rename the column.